IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[CGO_CharityDelete]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 ) 
  DROP PROCEDURE CGO_CharityDelete
GO

SET QUOTED_IDENTIFIER ON
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.CGO_CharityDelete
  @PortalID INT,
  @CharityID INT  
AS 
  DELETE  FROM dbo.CGO_Charity
  WHERE   CharityID = @CharityID
          AND PortalID = @PortalID

GO
